drop table deptlist;
create table deptlist(
	first_type number not null,
	second_type number not null,
	deptid varchar2(30) primary key,
	deptname varchar2(30) not null
);

drop sequence first_type_seq;
create sequence first_type_seq;

insert into deptlist values(first_type_seq.nextval, -1,'000', '부서1');
insert into deptlist values(first_type_seq.nextval, 1,'100', '부서2');
insert into deptlist values(first_type_seq.nextval, 2,'110', '부서3');
insert into deptlist values(first_type_seq.nextval, 2,'120', '부서4');
insert into deptlist values(first_type_seq.nextval, 1,'200', '부서5');
insert into deptlist values(first_type_seq.nextval, 1,'300', '부서6');
insert into deptlist values(first_type_seq.nextval, 6,'310', '부서7');
insert into deptlist values(first_type_seq.nextval, 7,'311', '부서8');
insert into deptlist values(first_type_seq.nextval, 7,'312', '부서9');
insert into deptlist values(first_type_seq.nextval, 7,'313', '부서10');
insert into deptlist values(first_type_seq.nextval, 1,'320', '부서11');
insert into deptlist values(first_type_seq.nextval, 11,'321', '부서12');
insert into deptlist values(first_type_seq.nextval, 1,'400', '부서13');
insert into deptlist values(first_type_seq.nextval, 13,'410', '부서14');
insert into deptlist values(first_type_seq.nextval, 13,'420', '부서15');